Gets an array of SQL connections objects that satisfy the query criteria
The response body is of type SQLGetResponse.
The collection of sql connections that satify the query.
Overview
![](template/packages/core-webservice/images/jsonschema.png) |
SQLGetResponse
The results of the points get query
![](template/packages/core-webservice/images/jsonschemacomplexarrayproperty.png) |
SQLDefaultConnections : Array[CimSQLConnection]
An array of the CimSQLConnection objects to create/update.
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
ODBCDataSource : string
ODBC Data connection.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
UserID : string
User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
Passsword : string
Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
ReconnectWaitPeriod : integer
The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
EnableStoreAndForward : boolean
Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
MaxNumberOfStoredRecord : number
To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.
| |
![](template/packages/core-webservice/images/jsonschemacomplexarrayproperty.png) |
SQLTableConnections : Array[CimSQLTableConnection]
An array of the CimSQLConnection objects to create/update.
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
Table_id : string
Table id on which connection is updated.
|
![](template/packages/core-webservice/images/jsonschemacomplexproperty.png) |
SQLConnection : CimSQLConnection
Fields that describe the connection to a SQL connection
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
ODBCDataSource : string
ODBC Data connection.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
UserID : string
User who will connect to the selected database driver. A database user name is required if you are connecting to a SQL Server.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
Passsword : string
Password needed to connect to the selected database driver. A password is required if you are connecting to a SQL Server.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
ReconnectWaitPeriod : integer
The amount of time that the Database Logger waits between reconnect attempts when the connection to the database is lost.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
EnableStoreAndForward : boolean
Choose enable store and forward to enable the ALARM_LOG table perform store and forward options.
|
![](template/packages/core-webservice/images/jsonschemaproperty.png) |
MaxNumberOfStoredRecord : number
To select the number of records the Database Logger will store when its connection to the database is down. Enter a number between 1 and 4294967285. 0 indicates no limit.
| | | |